SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471714 LIMIT 1 [ RunTime:0.000712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471714 [ RunTime:0.003000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501278,70067,726138,51849,599820,979208,814972,117280,163353,664764,720850,945841,561642,792454,532207,944972,1011599,809995,205654,105324,951403,323748,704746,232541,75600,423061,969856,662079,564701,803271,712687,216851,248614,306093,493251,352098,521744,337412,1005123,693046,470806,976290,545839,283416,33743,511157,890425,48659,339577,711291,287118,301770,299253,393865,942456,165499,591489,823145,224221,12378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]