SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654581 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654581 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786268,434985,250878,145180,2995,788771,235854,248134,456474,900818,805713,977167,676031,555047,525642,961562,158917,797598,775208,871029,402904,559862,498374,876259,1043983,402007,193538,468649,719478,362114,17639,695044,373142,665939,676854,945438,663687,300100,158307,130449,649669,42640,232511,274111,255043,937914,57222,502848,326287,816950,886177,983482,1010868,531901,312229,139157,731843,897429,993577,467244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]