SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343920 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343920 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65278,364110,919742,305215,370018,679142,574341,160212,1043516,882920,265348,705517,261815,140770,807228,340503,644378,728047,394418,34804,171528,58122,818218,207877,928261,389422,1015910,557621,774583,179877,65605,368655,1013600,276701,619723,138031,1046888,340747,1031219,471247,658772,85885,377235,1017411,379767,209210,467334,1003145,669677,658175,207250,462906,273401,303590,525510,37442,202363,991761,752609,708764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]