SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445703 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445703 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432341,1671,384634,243478,622019,902290,926255,77027,509211,814694,812831,907987,715809,194723,249483,1030633,368317,903543,55675,1019244,97360,283867,506065,761506,420677,834901,888682,107597,226669,129138,987106,927793,772629,550447,82970,162456,874671,655827,24269,341621,234861,1016028,13437,425301,1003262,84031,110304,616475,160784,414900,888856,510555,857246,573175,931055,1019524,304383,187622,887115,226676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]