SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029507 LIMIT 1 [ RunTime:0.001249s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029507 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495806,436512,205494,780071,32047,1032574,94036,260784,420830,1011245,20466,474019,291098,148176,2713,591371,603484,747681,391613,762913,593828,137414,669953,421349,751132,229649,437069,872841,859565,1034819,601862,368094,247004,312667,219307,6297,564708,19333,1002917,589026,854927,677410,21716,686932,791977,195330,738896,64573,768851,470870,169138,1029893,878029,476687,902070,622392,459489,397744,520276,832178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]