SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396150 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396150 [ RunTime:0.004310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572750,510140,580543,108167,760968,217129,73746,77741,330146,308825,102355,1005041,373802,521671,357606,784941,729993,89108,510552,1025056,871765,196811,928496,185770,183591,128380,891227,738265,278559,835169,824009,772916,37123,520807,929341,692869,359542,744743,1043134,484393,922969,367115,821583,715051,687919,762107,227343,165038,886295,748,40860,753861,698360,148602,936702,86914,595358,171473,724288,269791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]