SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80110 LIMIT 1 [ RunTime:0.000677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80110 [ RunTime:0.006613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259101,969996,542619,878606,236393,783783,227462,1030421,795066,919700,1001516,1045003,754031,639980,126786,441167,155587,444427,461630,711380,495725,27799,263816,392846,151682,1022751,975434,317452,451236,402009,97906,504200,855158,895707,936781,649023,135999,156857,665137,646051,820821,768125,792757,540591,803224,784984,928987,980968,214164,704139,499827,1025259,189505,64277,570562,484154,765060,623650,856099,1024510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]