SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596408 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596408 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442518,167413,830617,829840,229108,396200,241916,547317,323935,688659,113286,243514,62032,426549,922496,970422,378363,209697,102620,275465,101783,646744,218101,827932,759168,12540,939686,952348,115044,592516,450833,630827,611132,588965,327224,477037,1037363,870539,41363,876449,858824,438145,310311,907407,893204,18351,703735,369930,418415,835476,1006483,579290,681006,910850,17150,565512,373443,773348,721223,211710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]