SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431073 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431073 [ RunTime:0.004007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312795,122403,722608,657226,5023,531272,520264,395008,673051,911206,187058,378132,767388,697091,292725,313412,148293,335964,590128,371686,351678,655421,987048,116914,9874,188560,109077,906221,819068,107654,922572,325912,96899,217814,702382,512612,756358,925727,14091,1018955,626908,109039,818766,387187,537030,774524,449886,628105,885121,703069,201164,803111,23908,1003405,815615,41165,1640,811195,411444,686129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001193s ]