SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504660 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504660 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477156,206988,816031,889633,465638,619412,820747,308581,192122,58414,661510,1449,799995,439859,947960,725597,27241,984099,251934,313619,242826,214627,602844,134645,515116,375708,520636,564082,934494,279542,1019381,168938,879004,191169,450757,449826,319900,413305,815419,118552,535557,289984,383670,175334,468006,86996,845846,292123,1044043,96024,458325,88258,510430,484660,101464,104569,706498,530170,588314,478477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]