SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536218 LIMIT 1 [ RunTime:0.002123s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536218 [ RunTime:0.003426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485266,851352,231734,505635,161120,69559,421460,843242,577710,300827,850843,252304,298415,747245,90332,860453,228436,55098,845381,622394,563794,939330,84043,186720,792701,1045950,1013231,22896,496123,980230,140245,879514,529641,813732,611912,70625,418285,944577,893582,984761,558197,197985,162202,457051,299099,989666,808794,358009,950381,134970,830785,195186,911365,361433,952865,429863,370447,633805,795727,1035474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001135s ]