SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196463 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196463 [ RunTime:0.003320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666324,861679,221142,406196,165664,380854,203126,52254,842060,341642,615931,610044,824486,372982,855935,898300,447815,436039,989305,832060,193126,559682,803810,255665,735273,996683,229485,277495,383211,289582,116232,860150,167907,476817,505777,708159,608271,68101,899358,1022475,29427,420080,609232,68530,838130,914970,553226,73823,427371,32960,728078,1044175,404756,760690,569851,507530,410905,168253,11534,632313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]