SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282923 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282923 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936953,567240,696460,316874,607046,767744,303854,412810,196792,561981,921908,193652,1001046,543710,925090,904208,65155,16987,455270,527179,562928,76069,45036,109381,387381,202850,117239,830341,683764,16128,372720,306119,1003125,21624,685390,857198,872092,922003,862150,58198,387274,968390,931489,1044642,639176,958762,313646,849554,46760,425395,258491,1024873,627421,786003,448623,361225,805773,270824,921695,204860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]