SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508636 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508636 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557812,598153,1023239,207677,277329,734634,541344,961134,573557,368272,857075,117830,968864,572542,25832,607744,218707,643533,213184,272740,256790,332301,97121,939056,675824,11183,333563,5202,107553,557837,788889,937833,20905,708972,45093,56294,797287,338313,304624,235826,31191,960200,778990,801163,38949,605436,292748,51642,122475,560786,998868,406127,294069,151139,429927,616932,324667,689598,711263,744356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]