SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583103 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583103 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243559,2885,329889,963433,1009199,1036182,583059,508880,898324,886207,848284,391827,193822,640301,343922,493656,883172,361563,602532,942745,873500,544047,463835,865518,831552,394758,334193,961975,355511,36064,364753,596730,869201,225347,820869,15447,310202,600193,301889,337039,557493,726007,351544,164523,709697,670367,460024,77331,652486,515972,889846,886852,231412,297454,646699,306800,911397,502933,383141,73494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]