SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31978 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31978 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350039,644698,225278,22528,605136,722299,718231,598495,312971,930285,632807,98448,20296,871408,627137,855112,1003455,395650,531393,508543,147357,776338,737411,576616,41116,515331,887689,677383,985994,1005829,84544,313311,1018836,596106,983686,94585,758209,939049,285742,216649,51659,484860,40589,748555,928023,839087,638713,336366,146755,907245,31866,937067,472016,917020,578718,900144,962240,215137,181954,314960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]