SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380009 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380009 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526294,286619,603388,244886,387568,675625,419852,925993,250111,648482,537196,656062,514908,132656,519064,77053,335164,395542,93278,46951,839769,319785,329240,1021139,969750,926360,65753,605938,727993,762549,925463,199664,909868,647266,301901,95469,439868,484548,332712,43491,129289,734217,532718,608328,442892,13583,413610,54647,1019610,539549,14883,6164,287344,351556,438631,741841,359366,696044,344622,807473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001098s ]