SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531196 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531196 [ RunTime:0.001406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187773,443069,468075,70881,556368,316051,122491,862747,1003255,381627,631950,247410,757094,1001597,528623,939603,395818,251989,212073,233967,396953,563011,111040,478940,100373,675505,555327,316160,150355,144302,705850,244293,535596,235029,220680,473784,439717,943419,776680,530583,747161,446724,657433,91378,927372,625303,412381,215911,695720,158286,538154,585977,500125,523515,312900,467956,586144,33214,820181,732786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]