SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448516 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448516 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912024,297732,282433,136490,100414,778702,463740,297445,276787,690832,294813,300421,597619,937363,744870,832460,391156,576402,867364,827201,367472,242052,804695,450220,289981,75542,798325,301463,922787,956457,544747,76615,570601,926819,458763,454174,552062,401912,264519,766263,855981,222793,591252,17587,815012,815145,749010,593365,285289,1013706,530300,210199,717028,542827,577789,832486,768221,401188,746785,102763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]