SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382831 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382831 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698864,729973,1048462,1039756,542072,735678,535150,155220,920107,716872,681285,470477,805366,74314,700293,800769,339634,731484,271690,229909,969949,40114,921690,881519,294098,524352,903879,57714,424449,184719,458184,109424,717263,794365,897641,170593,838247,119602,626710,244753,434311,146643,323525,716203,793753,124558,962671,94191,791667,1037738,413644,555052,708883,59428,884604,15170,771475,1016370,854055,441357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]