SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687183 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687183 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65783,901118,446126,987766,943845,297924,858509,11663,872430,130324,648797,265126,1021563,65092,353475,549683,96398,774090,563487,142999,878728,215682,397554,443149,329568,912505,274363,509599,487307,1015322,487129,706747,495268,36655,886560,949033,31043,861194,332279,711690,513311,624149,636500,377631,133872,749500,470457,23504,669940,134951,372531,224340,191094,160170,680466,948878,829282,604680,485435,1045364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]