SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241711 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241711 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391195,1013955,167929,848512,950740,779815,812969,513986,640322,721079,238900,1040538,157957,890393,734439,622630,679730,777075,1009477,782496,234420,171660,336788,934035,65128,162063,522945,383134,893483,289562,748516,540951,839362,556229,589143,271760,324168,119110,382520,261961,369438,165005,307088,110143,327661,936614,600101,870277,814062,479386,664381,731276,196731,1016655,334647,421188,799486,94753,21772,581950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]