SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198610 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198610 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493696,878338,834188,681359,575987,340971,87328,565464,217609,550332,205713,702085,468769,477258,668069,934332,273679,756184,972108,167954,720407,561946,1009327,620628,770860,640273,486957,111506,564814,840222,1023377,453090,272155,757825,904422,387386,839743,388661,806877,794291,431810,476781,75607,539601,742483,903254,1003953,446410,422948,67263,103606,732876,804959,58889,237786,72760,656533,851219,725397,879862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]