SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533812 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533812 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928051,505032,969326,503677,527373,321720,1028520,548980,15847,375191,120881,139022,892447,423709,834783,106490,196021,876503,907646,608923,474302,679319,972016,724523,613511,139972,752421,445522,519127,978051,780343,235120,855546,986076,799308,90871,350261,498818,682702,181478,335645,785389,404621,515936,906133,497002,53087,731491,216868,409921,542528,133397,969484,584677,516486,138191,713848,547402,675320,810411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]