SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415088 LIMIT 1 [ RunTime:0.005814s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415088 [ RunTime:0.014058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595199,570141,928466,1014982,216045,726147,607121,1005590,334803,392197,1038193,794692,1044761,249231,471220,173196,548235,719350,825394,407294,327014,45852,599942,386094,14845,446304,216208,207601,529820,726548,1026993,343348,989320,80790,206354,892114,514974,742804,740308,378081,621550,568026,722583,194805,468458,372231,565481,297656,82407,400141,730663,308883,888075,1034934,682013,194621,673784,543193,962400,626026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]