SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500084 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500084 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843036,422076,199343,689431,262254,796470,619068,528256,189353,542148,161045,32128,210691,578689,765301,229801,647802,561048,973684,829690,879910,825368,898154,1024592,1001166,989939,736126,200366,820601,511860,193351,575980,346899,679620,838195,344400,374641,259962,33217,1003860,242482,505526,200069,56537,260688,582511,986081,743186,558326,267912,834067,644701,371789,340638,884433,32316,893916,770226,324689,937287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002069s ]