SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521043 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521043 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442102,768379,1002848,335934,467478,404794,755974,208563,832590,991000,1012288,523099,818809,844976,212983,400349,571769,754636,128536,627752,537013,270980,64918,855512,668594,1040022,872812,119396,173958,403349,1040913,318940,787714,111537,1034717,189140,747386,681431,1020306,280314,151575,849871,720530,70604,635182,731611,612679,447591,518385,36687,309825,975015,156283,139738,617331,406619,182255,972597,14777,521475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]