SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405169 LIMIT 1 [ RunTime:0.000851s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405169 [ RunTime:0.002740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032008,348592,156048,508067,178899,101932,606265,1027072,879235,574668,623172,700862,142262,246532,77158,61546,905393,513199,381304,553498,923752,288465,607023,918132,755314,171289,990877,417535,384570,509549,857621,770933,253573,943990,982907,467060,5883,693513,306085,377943,263960,70281,974780,693677,28082,712760,1044191,212795,255277,982954,440771,288454,162318,386218,782442,926542,674257,478287,1031472,703812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008388s ]