SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561231 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561231 [ RunTime:0.002697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287572,866765,12756,342617,338871,18237,973290,725327,1031719,711385,135066,872001,805310,1010613,266860,285361,523231,285587,327925,512203,423407,325857,669145,423006,649808,186806,743844,754835,965524,494130,24236,497697,103643,264677,607107,271349,556838,275018,60728,698189,875031,678360,519066,576984,1019885,676722,23450,71332,630832,690695,785552,66841,1015321,862707,444228,152378,169309,882833,500322,85186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]