SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047811 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047811 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439528,16223,457170,566398,411132,883217,914941,767350,13406,666476,831966,275945,249518,533896,531697,103811,80623,1018053,561596,702786,313396,198154,817751,1016127,657925,638393,349005,820065,977000,749342,693460,167503,239423,331588,570050,382029,440093,110680,104630,602916,620438,33435,70604,520884,746688,248102,873846,1042363,861531,792546,175308,533233,79364,480507,816418,159263,58126,182083,1045484,1031962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]