SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467909 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467909 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225137,274832,410705,582318,288610,193919,753177,359962,125925,1001366,897482,761717,716260,438971,718680,123883,840138,925528,483716,41265,228038,111413,226732,17432,526606,684879,758303,296937,440727,859952,799790,348058,224362,491149,886688,915136,33782,588506,260718,930074,140625,218608,607121,589638,724947,757966,864287,189442,457791,719379,15309,163193,515975,142953,1034798,109911,155043,911760,496994,803618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001303s ]