SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549198 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549198 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187728,755008,867944,750602,403036,296603,206486,397330,1001258,112825,883173,643045,892197,400816,78114,190926,45784,724996,1001076,229323,1026078,603141,777112,393875,401815,384681,658941,581933,215294,839565,714100,41512,552426,450852,517256,424102,519198,200666,838400,150625,956927,464784,229456,272653,883218,160166,661025,511959,572946,323071,229205,448444,1007123,302117,460333,161708,838250,123731,578819,1020964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]