SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 950043 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 950043 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449412,1043216,457019,527230,910606,389163,653738,497164,110884,730154,908209,833388,377352,1032721,946370,526543,476889,1020215,1029736,866401,470797,544186,747026,744868,115326,493341,846897,55105,173987,584562,712169,324479,388710,593244,920486,309993,317484,491072,672128,852898,201818,976998,187157,326012,596593,598816,889055,910186,483867,273016,625365,61808,875415,846725,568735,512078,728328,93970,359050,180053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 950043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 950043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004136s ]