SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401235 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401235 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005458,458765,330705,146225,1022370,869632,968718,477442,758494,479873,331667,294978,853108,840790,308138,1810,654346,992368,158517,869361,825475,101492,295096,537814,815071,417431,105783,68819,220936,567840,288402,420947,277643,685514,988964,844564,104613,733809,868928,685563,757675,362353,266218,563945,300878,767580,384528,25477,395017,730940,282978,2645,446192,147091,528384,564491,1016685,879255,203003,11186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]