SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591800 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591800 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769059,1035091,1010726,530784,156192,863430,817553,369252,232655,508085,719172,464941,350045,487502,472594,102857,463176,505822,624808,981274,619897,135075,178592,660538,950519,441365,334910,1010898,283101,979716,614628,464870,924602,313750,41828,441236,818888,78635,641624,391261,278524,624025,292396,371922,947397,827317,788022,464980,257458,1031785,793718,623283,891340,75839,184593,775193,786373,788795,1037105,518062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]