SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312316 LIMIT 1 [ RunTime:0.002244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312316 [ RunTime:0.003237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374547,739985,782108,706066,547528,637828,937629,324266,856393,396070,537256,244880,741728,43537,279684,443963,915371,1025657,440404,606695,315250,24779,174683,176735,446181,503495,482683,918852,755680,148683,882968,1016377,349684,385178,558943,203799,207899,939286,878471,579047,880783,124751,765466,524614,722999,33802,1048814,890581,530473,1036358,361322,425237,395422,105150,371495,608866,920519,594779,593168,135575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]