SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579422 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579422 [ RunTime:0.003536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505098,520890,328060,645974,42370,845990,404886,679097,821103,572592,134970,123254,217413,885752,214964,206930,360059,985408,174345,1030367,603858,201541,175391,120186,379635,135356,690394,301352,226095,932670,672112,1015549,821948,631202,528005,242732,18802,165373,737474,940181,694166,1016159,575236,249463,1000809,490200,455852,917691,1008888,604940,55157,770664,225051,753372,725347,418109,647353,945268,742685,188706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]