SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614516 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614516 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343915,757366,379733,1043634,456179,501704,368797,751020,726337,497539,267327,556546,323665,362944,821905,646025,378564,289675,49824,107638,737044,178981,688956,783976,1048695,382252,408145,583389,1032363,991407,525407,453404,307690,752213,800048,681538,939006,326852,880496,576641,19002,712118,337178,612061,597651,352855,1041264,759108,842079,815075,359511,354851,833063,255941,537263,195690,999259,130375,868835,190209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]