SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027564 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027564 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851768,1043512,903028,171852,578597,179698,566768,440936,467579,669888,37017,41415,511533,174324,242192,738199,117781,804413,218273,677138,212411,522906,684035,504367,86001,690537,688232,73853,302463,709623,212287,94531,896301,180768,836170,225197,793467,475067,728414,473212,636451,384797,903877,455378,391976,268678,400047,1037300,633879,724589,665348,400546,865831,632117,62426,800325,269504,733981,623008,181941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]