SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013800 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013800 [ RunTime:0.004489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508567,160327,78687,419812,549755,486553,464219,603452,57124,852960,234894,808616,4729,684935,543484,989547,175937,561050,884269,755649,938291,69853,104162,748247,14089,192537,541937,650252,614516,502952,933550,899413,706374,93147,739966,686772,870445,5060,532253,349428,375057,892082,977172,173056,577462,173243,14273,460963,835255,400807,41245,937664,1034438,788813,946034,776119,632596,40235,654062,1033595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]