SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039747 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039747 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268131,823899,81497,810035,647244,351401,462321,1042637,506733,331014,19805,122246,1017158,889615,160351,1037442,579101,702089,286211,652901,184873,645119,270689,604212,615279,186666,138189,829474,958377,531767,261454,330924,311886,700999,367977,35105,4030,115770,424293,156089,336022,857090,776065,594372,436297,107554,128754,666422,586944,222072,483895,698000,552603,395901,995784,665348,312142,529528,257861,861262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039747 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039747 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002728s ]