SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535933 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535933 [ RunTime:0.003470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915710,639448,114701,605845,278224,310806,679112,251925,530601,407491,1019017,624156,895541,408415,1035059,267831,631245,986777,767924,1012898,672070,168739,445884,191009,333021,549128,287520,920673,72052,995163,621845,714160,751671,967059,704831,228943,90844,1043394,392999,821860,705190,628417,335330,1025989,235847,227681,133240,1015448,1017822,332275,1027090,217991,941962,448191,239565,404284,577174,637850,718073,469531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000901s ]