SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540643 LIMIT 1 [ RunTime:0.005200s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540643 [ RunTime:0.003747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102040,639212,633071,136089,606831,1021503,13809,797061,20388,194056,774109,43518,826820,811916,374818,202839,115261,454146,407093,586618,189059,544553,444601,732433,131422,341486,680560,531107,502784,314835,651238,852531,338573,222126,937409,535745,58462,66561,1005399,672658,303772,924179,628070,843935,64459,1034843,163659,839043,228641,624055,747719,232951,478356,120841,87326,39748,847039,592796,941132,82821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]