SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457210 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457210 [ RunTime:0.003852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101786,585728,897067,818511,549682,425880,301646,491088,545388,294176,391774,991756,453089,444009,303868,582188,705512,362182,717659,876760,338829,492445,584621,737856,216516,617928,721366,92535,1033609,511321,232481,642830,48010,407031,280337,197230,996234,1040068,214077,353275,508497,7903,111521,219821,768752,48098,421918,937271,727237,944605,79149,376292,377451,685920,508634,390312,460877,542583,253785,732322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]