SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022789 LIMIT 1 [ RunTime:0.003942s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022789 [ RunTime:0.004578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17607,1014411,808698,1038654,276464,968513,1040820,749585,1040620,1035710,479942,264681,56970,488258,501811,258582,1035319,989761,288457,868685,1021596,702942,992356,259288,318827,228129,113000,946216,563182,214107,47597,188385,712879,217758,1044979,12422,794965,276604,449509,550884,696193,925546,131014,748599,384481,549715,17174,481253,640186,1020818,383050,820673,183354,960138,583754,224136,641056,698081,875577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022789 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022789 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]