SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394531 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394531 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807394,320350,400077,735934,901683,117765,820015,24800,590270,966292,522398,427466,525424,896636,631480,867977,500359,975803,946542,852878,487123,716707,205434,304987,950433,77809,651101,41140,146642,28398,466949,1005372,838271,25051,923006,985616,777052,551218,783265,245361,1048352,143211,364169,355073,68592,320061,975113,317106,94395,768084,798607,676306,852527,312288,328058,624776,621388,320529,543331,240713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]