SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517109 LIMIT 1 [ RunTime:0.001661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517109 [ RunTime:0.004234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343162,186209,971839,474003,527495,523161,214999,950488,822182,697023,730474,601024,71647,957794,981312,1020071,520699,93786,554082,364318,1023518,710069,660064,631998,225874,414264,977992,859336,853246,944814,66294,474133,909009,777158,557678,20180,3491,128231,36236,181100,151279,955458,214380,318432,457217,320839,871773,955660,654650,993428,976315,276780,401618,540526,1004876,632946,459148,1003690,271784,447422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002595s ]