SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445850 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445850 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864570,648950,204638,638949,1001921,480813,588380,685600,700858,460174,496175,519273,843652,144596,842781,865361,944393,256993,81719,796059,237703,139300,336530,928829,336313,926659,153379,29930,599421,861004,553703,678746,884133,717630,48555,276021,403671,258591,139392,927623,473601,632298,983466,525225,337622,356988,921865,1029737,258999,136867,561311,476016,799335,633186,610792,3858,692515,714449,644573,582780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]