SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526518 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526518 [ RunTime:0.004089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979104,625577,663038,117980,742241,286906,559519,621978,80583,233946,171838,729239,337256,994082,834151,812122,200039,687532,655585,1039202,283404,240926,776695,296828,526267,368878,925965,497312,515557,84907,1004652,819967,802042,315713,497784,738060,533504,872861,85646,154109,383845,597607,731508,228468,834921,943750,456679,141947,259485,394501,775633,882965,215555,988098,988974,271787,848615,11867,1039722,34642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]