SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620380,731712,788896,77076,59154,898822,795515,805165,147261,360844,582677,382453,12211,914506,364500,992592,987127,754819,202769,510957,676926,967330,179725,482684,398515,919094,555973,710352,136223,339016,781427,495890,802962,369018,529255,591573,659528,413800,1018788,127813,957029,917586,689693,69285,138949,37286,230445,6168,558986,716017,916102,120153,1037774,1045565,849196,646370,480991,283952,545448,170052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]