SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198413 LIMIT 1 [ RunTime:0.001936s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198413 [ RunTime:0.002610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304806,2379,117017,442303,419880,954247,36387,163086,288755,438192,1045785,1037597,24132,1028270,1021924,896886,679122,363915,13381,106522,472183,287060,920551,197778,229799,770006,401748,531827,196476,156362,112364,826903,100667,574737,535589,528211,339045,19229,981152,734268,721733,715450,64302,402199,713483,219008,5470,940805,792401,737662,631309,284951,1044443,574518,642242,182894,844523,94023,26157,12350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]