SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472513 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472513 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677567,530405,337026,826648,945961,147781,200703,315619,271321,223474,153118,261132,926055,475108,684915,873841,12490,342126,778370,215279,520608,1043361,920873,33064,881619,22795,861214,596012,996864,517134,129054,790877,5412,727057,331966,333876,995313,516093,903890,129269,275608,421275,996665,97149,871459,856631,21608,175878,158207,262708,737245,136543,906339,347759,1039489,837354,711828,837908,58076,920204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]