SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487580 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487580 [ RunTime:0.002997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031657,460948,852270,554505,888370,129619,124180,668231,424767,177225,648451,611476,253943,212031,378972,526426,255791,393364,842718,923291,55776,519609,964667,545525,622216,920715,75007,693656,207518,730799,210832,888160,323602,1040201,141883,2083,1044548,324621,944273,137870,130272,53934,347527,939405,393984,506851,678210,73243,677202,101034,446635,294362,1007381,218264,586156,22612,1041754,233691,685219,1035627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]