SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410809 LIMIT 1 [ RunTime:0.001016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410809 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352400,560940,125763,1017145,138085,64170,177543,907394,887826,178370,269535,562309,77928,637636,693191,787146,502064,453201,996240,812349,502017,520736,257462,562362,871964,949370,883452,492499,487380,741035,930498,64984,348512,822581,1004110,67750,1048324,512249,529232,437677,704640,317508,838651,62565,585013,362349,539552,899238,56900,102913,752547,658320,241952,322904,977486,627924,843568,66855,261427,436009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001857s ]