SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318320 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318320 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361703,2037,362712,108981,665825,425161,389500,120218,444395,163924,981647,253945,120417,742698,314991,529568,815380,1008566,60401,407313,190682,37974,819601,995689,1001895,570805,156800,50677,946456,818566,278938,122002,773428,422427,931660,924630,729581,468150,464872,1045333,632006,306120,31480,968905,291557,771636,11466,922461,944700,263017,71863,629716,130689,729456,421977,325573,469777,934262,334768,540139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]