SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405893 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405893 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126871,146140,358584,307254,163323,113626,835081,701917,125768,386182,760523,166891,464403,855936,168620,195056,862067,1001620,120586,787687,449180,644265,318337,138632,557065,433104,800520,904691,770943,144713,645961,602393,333057,522010,260762,236624,379526,780992,850502,1014667,848328,183363,843915,693404,52162,331508,581717,273227,789318,938257,1022998,306095,742679,709053,994801,335324,305214,884066,92193,184566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]