SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567343 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567343 [ RunTime:0.006683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897588,648867,526247,200169,218802,1015727,375090,706027,1009414,1028691,969745,41712,474452,781901,127719,564240,461112,519770,965944,43166,839285,111970,102470,429362,610370,842789,593269,576555,129565,753152,565441,21064,359286,696411,889501,965901,312466,549231,742763,849196,158350,262729,780523,285544,363300,1031462,192814,197125,23216,600538,452039,825360,1044305,664279,973984,555363,23994,276047,170757,488192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]