SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547191 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547191 [ RunTime:0.005009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658516,20636,416241,501553,936215,388282,771809,687548,286075,580939,495851,665937,61589,443407,439285,979064,903141,567615,604586,448747,551313,669445,579666,1014391,385283,769780,933399,504076,871802,401501,819219,516555,948204,946248,300559,926874,211612,518378,973384,66969,781449,792373,855034,629165,817967,896803,275577,533466,385245,830917,817654,834113,848478,674075,916658,138880,32595,336850,739906,888094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003384s ]