SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104858 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104858 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258674,747818,810904,588007,265375,339709,348730,202463,995961,225709,746813,574090,383027,884378,107752,933719,661371,332820,263018,701022,145740,741210,705671,798216,115657,725338,593621,902626,727216,475408,350914,868621,934798,830985,151109,922931,153953,177902,935801,859161,212487,683301,100433,506603,199920,1022087,171293,493789,122260,18671,838024,289093,520834,485741,917935,633860,189586,947907,1009597,529900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]