SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009071 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009071 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476907,220854,362431,615921,374713,806108,783218,911083,375553,981340,898347,871478,628195,954988,262830,521607,650435,183264,559484,821017,992,807298,189219,432008,134399,335556,739566,703877,50400,586175,817151,529820,310114,710824,28732,869036,241420,213059,339555,885152,354690,8414,312545,213176,603996,863487,500212,371863,41936,764726,714187,516698,73172,311661,45321,153040,53825,551693,647525,507368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]