SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317189 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317189 [ RunTime:0.002878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620030,451399,469887,499040,928422,723457,1015030,917506,980823,388157,426788,979429,883755,479032,391841,346940,380387,217222,215375,152863,301558,1041249,489883,634273,491465,318317,140309,417630,317041,289383,899690,261986,531502,960611,79591,19620,750197,757943,33088,188837,812793,39001,927685,390941,535132,364350,222781,438697,85220,123009,659383,66465,148882,559867,816651,787889,197145,537843,19261,754201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]