SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010118 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010118 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85086,327855,350421,653826,810525,808271,144862,197966,211509,991323,460178,1045010,12869,617218,847425,97607,906964,793644,354376,1034183,498443,177508,104636,147455,541373,552139,313886,501308,299781,321195,457136,261727,172699,79201,409507,94971,954447,559196,929580,750618,384652,555442,418505,215007,675142,314944,955926,599641,442875,246457,447887,400553,966562,723030,969774,1047805,645346,620665,221968,461788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]