SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407004 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407004 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210672,886212,714889,545422,72730,639352,700940,277371,1047678,795226,983799,932535,432662,766809,881928,411500,830817,102952,282032,874267,551313,983275,412627,872613,471293,859931,412134,832891,242445,180670,181917,698465,687469,42068,960125,561759,564770,463600,936661,267423,958746,273362,736009,80097,976184,366519,340218,638940,480833,1024726,209514,803678,269498,61009,209063,1031725,715594,346787,716388,16457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]