SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41663 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41663 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767522,971460,210123,136424,280696,480251,679344,67519,890251,819131,1021150,940809,944686,378749,1036277,563244,502464,459879,300049,468916,14496,64650,971478,333824,143869,479712,58878,88429,915435,655535,979446,913177,461698,434318,758224,1020001,983943,712020,558832,1007338,668258,741278,984483,378138,863327,678363,619118,295781,19424,781955,989075,1010019,552237,367238,476735,76466,827887,723782,593592,627129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]