SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409507 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409507 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153289,195842,497776,1024211,136518,843508,185478,467246,815378,599128,144795,1020844,301629,260395,374833,383982,643178,777044,151846,144299,622688,724047,995529,490737,366958,833658,136029,52980,970905,184572,903446,460321,250901,279832,259762,336808,577639,26280,813531,520107,468281,32383,24194,48699,582702,330158,411499,399234,468071,173705,1043146,474970,223773,598786,25878,361135,586855,264366,80019,706473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]