SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002798s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508448 LIMIT 1 [ RunTime:0.000871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508448 [ RunTime:0.009378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621504,193511,478009,727171,954517,667488,155981,197716,250429,317835,905621,1048067,812425,740130,445974,898520,840511,699565,476178,876864,244263,405157,861753,651778,766628,120267,443629,141147,1042851,102687,257374,288350,177185,998414,896089,285992,300072,105956,200669,1046842,1001059,353491,1021045,794098,529348,495184,1013888,84887,267643,806038,957223,313102,711157,374471,723985,451656,760710,472761,47396,400054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]