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` = 106234 LIMIT 1 [ RunTime:0.001036s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106234 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023278,72018,838680,224368,636284,784370,4556,885642,977272,118131,417636,116887,53447,239731,115713,623677,816201,3915,238150,430989,294988,482253,723655,67699,350750,928718,495953,978408,495071,21845,120927,964247,38742,306248,1002805,698001,204756,502419,292030,613820,37863,769956,1012027,898896,823802,257802,747801,108770,855031,294069,340436,655124,999864,31003,531162,840874,434399,485104,119805,221252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]