SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507510 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507510 [ RunTime:0.003236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970750,733516,454689,407495,735189,766606,864787,388815,816445,776760,755156,245852,339062,303263,670478,1041903,226477,870757,27076,981134,147700,835667,938711,221269,80301,631539,305781,653501,960146,308486,313823,477907,418318,137027,785167,601479,989244,193821,925925,280861,519496,551522,377705,775915,717232,303676,79054,233148,551323,1044390,77802,355274,864289,952570,356792,1013983,149890,824881,294119,678043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]