SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537075 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537075 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242042,1029015,498102,665673,308928,896395,346609,512997,995534,962580,396050,231585,287701,120305,861201,916697,471905,73889,421262,1035494,457595,94605,260169,858037,822441,627188,443949,362485,253233,310336,65499,187557,381027,864257,562431,58795,569604,619463,405742,845527,343090,296184,400889,156484,102823,335676,480980,108829,11315,737030,713430,819355,947100,1011390,74097,737939,201437,821247,911566,568343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]