SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413170 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413170 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1925,1017218,552230,166622,384499,256482,453127,473503,412773,57386,426851,1009334,955845,923008,236762,78876,448745,1008509,437958,442565,140272,413421,250255,506228,427144,660712,74685,184124,585444,541697,330848,467798,725330,192478,762467,1020127,316506,871560,986899,489763,193378,415227,495601,145179,948547,64707,130051,353326,148682,520285,104065,926321,2133,198607,769774,198635,719883,943519,439167,467971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]